CREATE TABLE [dbo].[Facility]
(
[Securities] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[RateOptions] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[RateLimits] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MultiCurrencies] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Marks] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Ratings] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SICs] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Spreads] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CallSchedule] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[WSODataFacilityID] [int] NOT NULL,
[Name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Type] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Country] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Notes] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Guarantor] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Purpose] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MaturityDate] [datetime] NOT NULL,
[OriginalCommitment] [float] NOT NULL,
[CurrentCommitment] [float] NOT NULL,
[CurrentOutstanding] [float] NOT NULL,
[FirstPaymentDate] [datetime] NOT NULL,
[CurrencyType] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[IsSynthetic] [bit] NOT NULL CONSTRAINT [DF__Facility__IsSynt__607251E5] DEFAULT ((0)),
[IsDelayedDraw] [bit] NOT NULL CONSTRAINT [DF__Facility__IsDela__6166761E] DEFAULT ((0)),
[IsDIP] [bit] NOT NULL CONSTRAINT [DF__Facility__IsDIP__625A9A57] DEFAULT ((0)),
[IsGuaranteed] [bit] NOT NULL CONSTRAINT [DF__Facility__IsGuar__634EBE90] DEFAULT ((0)),
[IsLCCreditLinked] [bit] NOT NULL CONSTRAINT [DF__Facility__IsLCCr__6442E2C9] DEFAULT ((0)),
[IsPositionClosed] [bit] NOT NULL CONSTRAINT [DF__Facility__IsPosi__65370702] DEFAULT ((0)),
[IsFixed] [bit] NOT NULL CONSTRAINT [DF__Facility__IsFixe__662B2B3B] DEFAULT ((0)),
[TradesWithAccrued] [bit] NOT NULL CONSTRAINT [DF__Facility__Trades__671F4F74] DEFAULT ((0)),
[AbbrevName] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[HasLCSublimit] [bit] NOT NULL CONSTRAINT [DF__Facility__HasLCS__681373AD] DEFAULT ((0)),
[LCSublimit] [decimal] (19, 4) NOT NULL,
[Seniority] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[LienType] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[IssuePrice] [decimal] (19, 4) NOT NULL,
[PaymentFrequency] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[StatedxIBORSpread] [real] NOT NULL,
[MinAssignment] [real] NOT NULL,
[MinHold] [real] NOT NULL,
[IssuingBankConsent] [bit] NOT NULL CONSTRAINT [DF__Facility__Issuin__690797E6] DEFAULT ((0)),
[Collateral] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[IsDefault] [bit] NOT NULL CONSTRAINT [DF__Facility__IsDefa__69FBBC1F] DEFAULT ((0)),
[ActivityTracked] [bit] NOT NULL CONSTRAINT [DF__Facility__Activi__6AEFE058] DEFAULT ((0)),
[CAVerified] [bit] NOT NULL CONSTRAINT [DF__Facility__CAVeri__6BE40491] DEFAULT ((0)),
[LastUpdate] [datetime] NOT NULL
) ON [PRIMARY]
GO
